CDISC Builder™  2.1 - Installation Test Scripts - Metadata
The following documentation contains test scripts and expected results for validating the CDISC Builder Metadata tool.  Do the following to verify proper installation:
  • Start CDISC Builder application by double clicking on the desktop icon.
  • Perform each test by performing the steps specified by the instructions.  
  • Evaluate the results of each step by comparing them with results described in the Documentation column. 
Script Description Documentation
Source Data Type invalid path.
Navigate to location with no SAS datasets.
Path name that is longer than 200 characters.
Use [...] path navigation.
 		 Instructions 1  
Data Sets List of datasets match what is in the selected path.
Verify preview button with a separate PROC PRINT.
Verify select all button toggle.
 		 Instructions 2
Metadata Database The [...] library manager returns the last libname selected 
Default to METADB for dataset name.  
Instructions 3

Output Report

 Verify default output file is metadb.html in current default directory.
Verify name that is long over 200 characters.  Proper warning message is presented.
Verify the [...] returns the correct path
 Instructions 4
OK/Cancel OK button applies all selected parameters.
Memory of all fields is retained.
Cancel does not apply logic.
  		Instructions 5
Save Code Program is saved with proper comments
Generated program is submitted and results verified
 		 Instructions 6
Search Default source data path is same with main screen
List of datasets is what has been registered.  Verify with PROC PRINT of METADB.
Search criteria with special characters such as comma and quotes.
Verify case insensitive and case sensitive searches.
 Instructions 7

Instructions 1
Start the CDISC Builder application from the icon in desktop.

  1. Create the following path if it does not already exist.

    c:\temp\cdiscbuilder\input
    c:\temp\cdiscbuilder\source
    c:\temp\cdiscbuilder\output
     

  2. Submit the following program:

    libname input 'C:\temp\cdiscbuilder\input';
    libname source 'C:\temp\cdiscbuilder\source';
    libname output 'C:\temp\cdiscbuilder\output';

    data testlib.shoes;
             set sashelp.shoes;
    run;
    data testlib.company;
             set sashelp.company;
    run;
    data testlib.manage;
             set sashelp.manage;
    run;
    data testlib.ae(label="Adverse Event");
             set sashelp.ae;
    run;
     

  3. At the Main screen, select Source Data as 'C:\temp\cdiscbuilder\input' and Data Sets as AE.

  4. Click on Metadata icon to open Metadata screen.

  5. Verify that Source Data is 'C:\temp\cdiscbuilder\input' and Data Sets as AE.

  6. Type an invalid path such as 'C:\invalid' in Source Data textbox and hit Enter key.

  7. Verify that there is a warning message box as the following:

    • The field (Source Data) contains an invalid directory.

  8. Click OK to close the message box. Verify that Datasets list box is empty.

  9. Type 'C:\temp\cdiscbuilder\input' in Source Data textbox and hit Enter key.

  10. Verify that all datasets in 'C:\temp\cdiscbuilder\input' are inserted in Datasets list box.

  11. Type an empty directory such as 'C:\temp\empty' in Source Data textbox and hit Enter key.

  12. Verify that Datasets list box is empty.

  13. Create a directory that is longer than 200 characters such as:
     C:\temp\This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path.
     

  14. Type this path in Source Data textbox and hit Enter key. Verify that there is no error.

  15. Click on [...] button next to Source Data textbox.

  16. Select 'C:\temp\cdiscbuilder\input' path and then click OK.

  17. Verify that Datasets list box is filled with all datasets in 'C:\temp\cdiscbuilder\input'.

  18. Click on [...] button next to Source Data textbox.

  19. Select the path 'C:\temp\This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path. This is a test of long path.'.

  20. Click OK button. Verify that there is a warning message as the following:

    • You can not select a path longer than 200 characters using Select dialog. Please enter the path directly to the Source Data field.

Instructions 2
Start the CDISC Builder application from the icon in desktop.

  1. Click on Metadata icon to open Metadata screen.

  2. At the Metadata screen, type 'C:\temp\cdiscbuilder\input' in Source Data textbox and hit Enter key.

  3. Verify that all datasets in 'C:\temp\cdiscbuilder\input' are inserted in Datasets list box and dataset AE is selected.

  4. Click on Preview button. Verify that the first 100 observations of dataset AE is displayed.

  5. Open SAS program and submit the following code:

    libname input 'C:\temp\cdiscbuilder\input';
    proc print data=input.ae;
    run;
     

  6. Verify that the result of the above code is the same with the result of the Preview button.

  7. Click on the Select All button. Verify that all datasets in Datasets list box are selected.

  8. Click on the Select All button again. Verify that no dataset in Datasets list box is selected.

Instructions 3
Start the CDISC Builder application from the icon in desktop.

  1. Click on Metadata icon to open Metadata screen.

  2. At the Metadata screen, type 'C:\temp\cdiscbuilder\input' in Source Data textbox and hit Enter key.

  3. Verify that all datasets in 'C:\temp\cdiscbuilder\input' are inserted in Datasets list box.

  4. Select AE from the Datasets list box.

  5. Click on [...] button next to Metadata Database. Verify that Libname Management is displayed.

  6. Select library OUTPUT and then click Back button.

  7. Verify that the  libname OUTPUT is selected in the Metadata Database combo box and the dataset textbox has the default value METADB.

Instructions 4
Start the CDISC Builder application from the icon in desktop.

  1. Click on Metadata icon to open Metadata screen.

  2. At the metadata screen, type 'C:\temp\cdiscbuilder\input' in Source Data textbox and hit Enter key.

  3. Verify that all datasets in 'C:\temp\cdiscbuilder\input' are inserted in Datasets list box.

  4. Select AE from the Datasets list box.

  5. Verify that Output Report textbox has default value file metadb.html with the input path.

  6. Input a path that is more than 200 characters. Verify that could not input more that 200 charecters in the Output Report textbox.

  7. Input 'C:\temp\cdiscbuilder\output\metadb.html' in Output Report textbox.

  8. Click on [...] button next to the Output Report textbox.

  9. Verify that Save As dialog box is displayed. Verify that the path of Save As dialog box is 'C:\temp\cdiscbuilder\outout'.

  10. Select 'C:\temp\cdiscbuilder\metadb.html'. Click OK button.

  11. Verify that Output Report textbox has the value 'C:\temp\cdiscbuilder\metadb.html'.

Instructions 5
Start the CDISC Builder application from the icon in desktop.

  1. Click on Metadata icon to open Metadata screen.

  2. At the metadata screen, type 'C:\temp\cdiscbuilder\input' in Source Data textbox and hit Enter key.

  3. Verify that all datasets in 'C:\temp\cdiscbuilder\input' are inserted in Datasets list box.

  4. Select AE from the Datasets list box.

  5. Select OUTPUT.metadb in Metadata Database.

  6. Select Update in the Task combo box.

  7. Input 'C:\temp\cdiscbuilder\output\metadb.html' in Output Report textbox.

  8. Click OK button to apply metadata logic.

  9. At the Result Status dialog. Verify that there is no error message.

  10. Click Back to return to Metadata screen.

  11. Verify that there is a message as the following:

    • Press F5 to refresh result viewer if you want to view sample code.

  12. Click Cancel button to return to them main screen.

  13. Click Metadata to open Metadata screen. Verify that all parameters retain.

Instructions 6
Start the CDISC Builder application from the icon in desktop.

  1. Click on Metadata icon to open Metadata screen.

  2. At the Metadata screen, click Save Code button. Verify that Save Code dialog is displayed.

  3. Input the path as 'C:\temp\cdiscbuilder' and the file name as 'metadata_AE'.

  4. Click OK button. Verify that View Code screen is displayed.

  5. Review the code and verify that all the parameters are inserted in the right order of the macro.

  6. Click Back button to return to the Metadata screen.

  7. Navigate to the 'C:\temp\cdiscbuilder' directory.

  8. Submit the 'metadata_AE.sas' program and verify that the result is the same with the result of the instructions 5.

Instructions 7
Start the CDISC Builder application from the icon in desktop

  1. Click on Metadata icon to open Metadata screen.

  2. Perform Instructions 5 with dataset COMPANY.

  3. At the Metadata screen, click Search button. Verify that METADATA Search screen is displayed.

  4. Verify that Source data textbox has the same with the path that library OUTPUT point to.

  5. Open SAS program and submit the following code:

    libname output 'C:\temp\cdiscbuiler\output';
    proc print data=output.metadb;
    run;
     

  6. Verify that there are 2 values AE and COMPANY at column Memname of the result.

  7. Verify that there are 2 values AE and COMPANY in the Datasets list box.

  8. Input special characters such as: !@#$%^&*()<>?,./;:'" into Search Criteria textbox.

  9. Click OK button. Verify that there is a warning message box as the following: The field (Search Criteria) contains some special characters.

  10. Click OK to close the message box.

  11. Select dataset COMPANY in Datasets list box.

  12. Type 'DEPTH' in Search Criteria textbox.

  13. Click OK button. Verify that there is a row that has string 'DEPTH' in the result.

  14. Close the result. Type 'depth' in Search Criteria textbox and check Case Sensitive checkbox.

  15. Click OK  button. Verify that there is no row that match string 'depth' in the result.

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009